<?php die('forbidden'); ?>
DROP TABLE IF EXISTS eb_ad;
CREATE TABLE `eb_ad` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号',
  `typeid` mediumint(8) unsigned NOT NULL COMMENT '广告分类ID号',
  `subject` varchar(255) NOT NULL COMMENT '广告题头，用于后台管理',
  `content` text NOT NULL COMMENT '广告内容',
  `status` tinyint(1) unsigned NOT NULL default '0' COMMENT '0为未审核，1为正常',
  `start_date` date NOT NULL default '2008-02-29' COMMENT '广告开始时间',
  `end_date` date NOT NULL default '2020-02-29' COMMENT '广告结束时间',
  PRIMARY KEY  (`id`),
  KEY `typeid` (`typeid`),
  KEY `start_date` (`start_date`,`end_date`,`status`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_admin;
CREATE TABLE `eb_admin` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `typer` enum('system','manager','editor') NOT NULL default 'editor',
  `user` varchar(100) NOT NULL default '',
  `pass` varchar(50) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `modulelist` text NOT NULL COMMENT '可管理的模块，系统管理员无效',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_book;
CREATE TABLE `eb_book` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `typeid` mediumint(8) unsigned NOT NULL default '0' COMMENT '留言分类ID',
  `userid` mediumint(8) unsigned NOT NULL default '0',
  `user` varchar(255) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `postdate` int(10) unsigned NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `ifcheck` tinyint(3) unsigned NOT NULL default '0' COMMENT '0为未审核，1为已审核所有人可以看，2为已审核但仅限会员能查看',
  `language` mediumint(8) unsigned NOT NULL default '0',
  `reply` text NOT NULL,
  `replydate` int(10) unsigned NOT NULL default '0' COMMENT '回复时间',
  PRIMARY KEY  (`id`),
  KEY `language` (`language`),
  KEY `typeid` (`typeid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_category;
CREATE TABLE `eb_category` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号，也是分类ID号',
  `sysgroupid` mediumint(8) unsigned NOT NULL default '0' COMMENT '系统组ID',
  `rootid` mediumint(8) unsigned NOT NULL default '0' COMMENT '根分类ID号',
  `parentid` mediumint(8) unsigned NOT NULL default '0' COMMENT '父分类ID号',
  `catename` varchar(255) NOT NULL default '' COMMENT '分类名称',
  `catestyle` varchar(255) NOT NULL default '' COMMENT '样式',
  `taxis` tinyint(3) unsigned NOT NULL default '255' COMMENT '排序，值越小越往前靠',
  `tpl_index` varchar(255) NOT NULL default '' COMMENT '封面模板',
  `tpl_list` varchar(255) NOT NULL default '' COMMENT '列表模板',
  `tpl_msg` varchar(255) NOT NULL default '' COMMENT '内容模板',
  `note` varchar(255) NOT NULL default '' COMMENT '描述',
  `status` tinyint(1) unsigned NOT NULL default '1' COMMENT '1为正常，0为隐藏',
  `language` mediumint(8) unsigned NOT NULL default '0' COMMENT '语言ID',
  `psize` tinyint(3) unsigned NOT NULL default '30' COMMENT '分类列表每页显示个数，默认是30',
  `isrefreshcount` tinyint(1) unsigned NOT NULL default '1' COMMENT '是否更新数量统计，0为不更新，1为要更新',
  `msgcount` int(10) unsigned NOT NULL default '0' COMMENT '内容数量',
  `showtype` tinyint(1) unsigned NOT NULL default '0' COMMENT '0按orderdate排序，1按postdate最新排序，2点击量最多排前，3点击量少排前',
  `pic` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `status` (`status`,`language`),
  KEY `rootid` (`rootid`,`status`,`language`),
  KEY `parentid` (`parentid`,`status`,`language`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_feedback;
CREATE TABLE `eb_feedback` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `userid` mediumint(8) unsigned NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `postdate` int(10) unsigned NOT NULL default '0',
  `reply` text NOT NULL,
  `replydate` int(10) unsigned NOT NULL default '0' COMMENT '回复时间',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_job;
CREATE TABLE `eb_job` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号，也是应聘链接的ID',
  `jobname` varchar(255) NOT NULL default '' COMMENT '职位名称',
  `usercount` tinyint(3) unsigned NOT NULL default '0' COMMENT '0表示不限个数',
  `age` varchar(255) NOT NULL default '' COMMENT '年龄阶段要求',
  `experience` varchar(255) NOT NULL default '' COMMENT '是否要求有工作经验',
  `height` varchar(255) NOT NULL default '' COMMENT '身高范围',
  `gender` tinyint(1) unsigned NOT NULL default '0' COMMENT '0为不限，1表示男性，2表示女性',
  `content` text NOT NULL COMMENT '其他说明要求',
  `postdate` int(10) unsigned NOT NULL default '0' COMMENT '发布时间',
  `enddate` int(10) unsigned NOT NULL default '0' COMMENT '为0表示长期招聘',
  `language` mediumint(8) unsigned NOT NULL default '0' COMMENT '语言ID',
  PRIMARY KEY  (`id`),
  KEY `language` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_jobapp;
CREATE TABLE `eb_jobapp` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号',
  `jobid` mediumint(8) unsigned NOT NULL default '0' COMMENT '对应的招聘的ID号！',
  `userid` mediumint(8) unsigned NOT NULL default '0' COMMENT '会员ID号，非会员为0',
  `jobname` varchar(255) NOT NULL default '' COMMENT '应聘的职位，对应招聘的jobname',
  `name` varchar(100) NOT NULL default '' COMMENT '应聘者姓名',
  `age` tinyint(2) unsigned NOT NULL default '0' COMMENT '应聘者年龄',
  `height` tinyint(3) unsigned NOT NULL default '150' COMMENT '身高',
  `schoolage` varchar(255) NOT NULL default '' COMMENT '学历',
  `contact` varchar(255) NOT NULL default '' COMMENT '联系方式',
  `photo` varchar(255) NOT NULL default '' COMMENT '照片',
  `note` text NOT NULL COMMENT '个人说明',
  `postdate` int(10) unsigned NOT NULL default '0' COMMENT '应聘时间',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_lang;
CREATE TABLE `eb_lang` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号',
  `sign` varchar(30) NOT NULL default '' COMMENT '语言标识',
  `name` varchar(200) NOT NULL default '' COMMENT '语言名称',
  `ifuse` tinyint(3) unsigned NOT NULL default '0' COMMENT '是否使用，1为使用，0为停用',
  `ifdefault` tinyint(3) unsigned NOT NULL default '0' COMMENT '默认语言包',
  `ifsystem` tinyint(3) unsigned NOT NULL default '0' COMMENT '是否系统默认，0为否，1为是',
  `template` mediumint(8) unsigned NOT NULL default '0' COMMENT '语言对应的默认模板',
  `langc` longtext NOT NULL COMMENT '语言变量内容',
  `od` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_link;
CREATE TABLE `eb_link` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `picture` varchar(255) default NULL,
  `taxis` tinyint(3) unsigned default '255',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_mailmsg;
CREATE TABLE `eb_mailmsg` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号',
  `language` mediumint(8) unsigned NOT NULL default '0' COMMENT '语言包',
  `subject` varchar(255) NOT NULL default '' COMMENT '主题',
  `content` text NOT NULL COMMENT '内容',
  `usetype` varchar(100) NOT NULL default '' COMMENT '应用类型',
  PRIMARY KEY  (`id`),
  KEY `language` (`language`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_mailstatus;
CREATE TABLE `eb_mailstatus` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号，在这里无效',
  `status` tinyint(1) unsigned NOT NULL default '0' COMMENT '1为开启邮件通知，0为不开启邮件通知',
  `sign` varchar(100) NOT NULL default '' COMMENT '签名，自动附加在邮件通知的最后内容',
  `language` mediumint(8) unsigned NOT NULL default '1' COMMENT '语言ID',
  PRIMARY KEY  (`id`),
  KEY `language` (`language`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_msg;
CREATE TABLE `eb_msg` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT '信息自增ID号',
  `cateid` mediumint(8) unsigned NOT NULL default '0' COMMENT '分类ID对应category表的自增ID号',
  `subject` varchar(255) NOT NULL default '' COMMENT '主题',
  `style` varchar(255) NOT NULL default '' COMMENT '主题CSS样式',
  `author` varchar(50) NOT NULL default '' COMMENT '作者名称',
  `authorid` mediumint(8) unsigned NOT NULL default '0' COMMENT '作者ID号',
  `postdate` int(10) unsigned NOT NULL default '0' COMMENT '发布时间',
  `modifydate` int(10) unsigned NOT NULL default '0' COMMENT '更改时间',
  `thumb` mediumint(8) unsigned NOT NULL default '0' COMMENT '缩略图图片ID号',
  `tplfile` varchar(255) NOT NULL default '' COMMENT '模板文件，为空使用系统默认',
  `hits` int(10) unsigned NOT NULL default '0' COMMENT '点击率',
  `orderdate` int(10) unsigned NOT NULL default '0' COMMENT '排序时间，时间越大越往前排',
  `istop` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否置顶，0为普通，1－9为不同级别的置顶',
  `isvouch` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否推荐，0为不推荐，1－9为不同级别的推荐',
  `isbest` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否精华，0为普通，1－9为不同级别的精华',
  `onlysign` varchar(50) NOT NULL default '' COMMENT '唯一标识符，该标识符是在程序中创建，在数据库里没有对唯一性进行检查',
  `ext_url` varchar(255) NOT NULL default '' COMMENT '自定义链接',
  `ext_docket` varchar(255) NOT NULL default '' COMMENT '自定义接要',
  `ext_marketprice` float unsigned NOT NULL default '0' COMMENT '自定义市场价',
  `ext_shopprice` float unsigned NOT NULL default '0' COMMENT '商城价',
  `ext_standard` varchar(255) NOT NULL default '' COMMENT '商品规格',
  `ext_number` varchar(255) NOT NULL default '' COMMENT '商品型号',
  `ext_size` varchar(255) NOT NULL default '' COMMENT '软件大小，单位记得填写单位KB，MB等',
  `ext_0` varchar(255) NOT NULL default '' COMMENT '自定义字段0',
  `ext_1` varchar(255) NOT NULL default '' COMMENT '自定义字段1',
  `ext_2` varchar(255) NOT NULL default '' COMMENT '自定义字段2',
  `ext_3` varchar(255) NOT NULL default '' COMMENT '自定义字段3',
  `ext_4` varchar(255) NOT NULL default '' COMMENT '自定义字段4',
  `ext_5` varchar(255) NOT NULL default '' COMMENT '自定义字段5',
  `ext_6` varchar(255) NOT NULL default '' COMMENT '自定义字段6',
  `ext_7` varchar(255) NOT NULL default '' COMMENT '自定义字段7',
  `ext_8` varchar(255) NOT NULL default '' COMMENT '自定义字段8',
  `ext_9` varchar(255) NOT NULL default '' COMMENT '自定义字段9',
  `ifcheck` tinyint(1) unsigned NOT NULL default '1' COMMENT '1为已审核，0为未审核',
  `state` int(6) NOT NULL default '0',
  `images` varchar(100) NOT NULL,
  `isShop` tinyint(1) NOT NULL default '0',
  `onsaledate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`,`cateid`),
  KEY `cateid` (`cateid`,`ifcheck`)
) ENGINE=MyISAM AUTO_INCREMENT=229 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_msg_content;
CREATE TABLE `eb_msg_content` (
  `id` int(10) unsigned NOT NULL default '0' COMMENT '主题ID号，对应msg表中的自增ID号',
  `cateid` mediumint(8) unsigned NOT NULL default '0' COMMENT '分类ID号，用于索引',
  `content` longtext NOT NULL COMMENT '内容信息',
  `buylink` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `cateid` (`cateid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_nav;
CREATE TABLE `eb_nav` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `css` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `target` tinyint(3) unsigned NOT NULL default '0',
  `taxis` tinyint(3) unsigned NOT NULL default '255',
  `language` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_notice;
CREATE TABLE `eb_notice` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `language` mediumint(8) unsigned NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '' COMMENT '公告链接的网址',
  `content` text NOT NULL,
  `postdate` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `language` (`language`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_order;
CREATE TABLE `eb_order` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号',
  `sn` varchar(100) NOT NULL default '' COMMENT '订单唯一编号',
  `userid` mediumint(8) unsigned NOT NULL default '0' COMMENT '会员ID号，非会员为0',
  `user` varchar(255) NOT NULL default '' COMMENT '会员账号，非会员为联系人姓名',
  `msgid` mediumint(8) unsigned NOT NULL default '0' COMMENT '主题ID号，对msg表中的id，无关联为0',
  `subject` varchar(255) NOT NULL default '' COMMENT '主题',
  `msgcount` varchar(30) NOT NULL default '0' COMMENT '订购数量',
  `unitprice` float unsigned NOT NULL default '0' COMMENT '商品单价',
  `totalprice` varchar(30) NOT NULL default '' COMMENT '商品总价格',
  `note` varchar(255) NOT NULL default '' COMMENT '简单的备注说明',
  `contactmode` varchar(100) NOT NULL default '' COMMENT '联系方式，可填写手机、电话或邮箱',
  `address` varchar(255) NOT NULL default '' COMMENT '联系地址',
  `zipcode` varchar(30) NOT NULL default '' COMMENT '邮政编码',
  `postdate` int(10) unsigned NOT NULL default '0' COMMENT '操作时间',
  `email` varchar(255) NOT NULL default '' COMMENT '联系邮箱',
  `status` tinyint(1) unsigned NOT NULL default '0' COMMENT '0为未查看，1为已查看',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_special;
CREATE TABLE `eb_special` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号，也是专题ID号',
  `typeid` mediumint(8) unsigned NOT NULL default '0' COMMENT '分类ID号',
  `subject` varchar(255) NOT NULL default '' COMMENT '专题名称',
  `style` varchar(255) NOT NULL default '' COMMENT 'CSS样式',
  `content` text NOT NULL COMMENT '专题内容',
  `url` varchar(255) NOT NULL default '' COMMENT '跳转网址',
  `taxis` tinyint(3) unsigned NOT NULL default '255' COMMENT '排序，值越小越往前靠',
  `language` mediumint(8) unsigned NOT NULL default '0' COMMENT '语言分类',
  `ifcheck` tinyint(1) unsigned NOT NULL default '1' COMMENT '专题状态，0为锁定，1为正常',
  `remark` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `typeid` (`typeid`),
  KEY `language` (`language`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_sysgroup;
CREATE TABLE `eb_sysgroup` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号，也是组ID号',
  `groupname` varchar(100) NOT NULL default '' COMMENT '组名称',
  `isext_url` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否自定义网址',
  `isext_docket` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否使用摘要',
  `isext_price` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否使用价格',
  `isext_standard` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否启用规格',
  `isext_number` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否启用编号',
  `isext_size` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否启用大小，一般用于软件下载',
  `isext_download` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否启用下载网址管理',
  `ext_0_name` varchar(255) NOT NULL default '' COMMENT '自定义字段0的名称',
  `ext_1_name` varchar(100) NOT NULL default '' COMMENT '自定义字段1的名称',
  `ext_2_name` varchar(100) NOT NULL default '' COMMENT '自定义字段2的名称',
  `ext_3_name` varchar(100) NOT NULL default '' COMMENT '自定义字段3的名称',
  `ext_4_name` varchar(100) NOT NULL default '' COMMENT '自定义字段4的名称',
  `ext_5_name` varchar(100) NOT NULL default '' COMMENT '自定义字段5的名称',
  `ext_6_name` varchar(100) NOT NULL default '' COMMENT '自定义字段6的名称',
  `ext_7_name` varchar(100) NOT NULL default '' COMMENT '自定义字段7的名称',
  `ext_8_name` varchar(100) NOT NULL default '' COMMENT '自定义字段8的名称',
  `ext_9_name` varchar(100) NOT NULL default '' COMMENT '自定义字段9的名称',
  `sign` varchar(50) NOT NULL default '' COMMENT '唯一标识',
  `tplindex` varchar(100) NOT NULL default '' COMMENT '默认封面模板',
  `tpllist` varchar(100) NOT NULL default '' COMMENT '默认列表模板',
  `tplmsg` varchar(100) NOT NULL default '' COMMENT '默认内容模板',
  `is_thumb` tinyint(1) unsigned NOT NULL default '1' COMMENT '是否启用内容',
  `isState` tinyint(1) NOT NULL default '0',
  `isImages` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `sign` (`sign`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_tpl;
CREATE TABLE `eb_tpl` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号',
  `name` varchar(255) NOT NULL default '' COMMENT '风格名称',
  `folder` varchar(255) NOT NULL default '' COMMENT '文件夹',
  `taxis` tinyint(3) unsigned NOT NULL default '255' COMMENT '排序，值越小越往前靠',
  `language` mediumint(8) unsigned NOT NULL default '0' COMMENT '语言ID',
  `isdefault` tinyint(1) unsigned NOT NULL default '0' COMMENT '是否默认',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_upfiles;
CREATE TABLE `eb_upfiles` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号，也是附件的ID号',
  `filetype` varchar(10) NOT NULL COMMENT '文件格式，如jpg,gif等',
  `tmpname` varchar(255) NOT NULL default '' COMMENT '原文件名称，即在客户端显示的名称',
  `filename` varchar(255) NOT NULL default '' COMMENT '新文件名称，这是以时间及随机数整合生成的唯一值',
  `folder` varchar(255) NOT NULL default '' COMMENT '文件目录，基于网站的根目录的路径',
  `postdate` int(10) unsigned NOT NULL default '0' COMMENT '上传时间',
  `thumbfile` varchar(255) NOT NULL default '' COMMENT '缩略图文件，假如附件是图片的话',
  `markfile` varchar(255) NOT NULL default '' COMMENT '水印图文件，假如附件是图片的话',
  PRIMARY KEY  (`id`),
  KEY `filetype` (`filetype`)
) ENGINE=MyISAM AUTO_INCREMENT=444 DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_user;
CREATE TABLE `eb_user` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `user` varchar(100) NOT NULL default '',
  `nickname` varchar(255) NOT NULL default '',
  `realname` varchar(255) NOT NULL default '',
  `pass` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `phone` varchar(30) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `postmail` varchar(30) NOT NULL default '',
  `regdate` int(10) unsigned NOT NULL default '0' COMMENT '注册时间',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS eb_vote;
CREATE TABLE `eb_vote` (
  `id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '自增ID号',
  `voteid` mediumint(8) unsigned NOT NULL default '0' COMMENT '是否是主题，0为主题，其他ID为选项',
  `subject` varchar(255) NOT NULL default '' COMMENT '主题或被选项名称',
  `vtype` enum('single','pl') NOT NULL default 'pl' COMMENT '投票类型，single单选，pl是复选',
  `vcount` int(10) unsigned NOT NULL default '0' COMMENT '票数',
  `language` mediumint(8) unsigned NOT NULL default '0' COMMENT '语言包ID',
  `ifcheck` tinyint(1) unsigned NOT NULL default '0' COMMENT '默认是否选中，0为不选中，1为选中',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

